<?php 
session_start(); 
	
	if (!$_SESSION["id_no"])
    {
        Header("Location: index.php");
    }
	else{
		if ($_SESSION['account_type']=='root'){
			$header="secured/header_login";
		}
		else{ 
			$header="header";
		}
	}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Ralimo System Panel</title>
<link rel="stylesheet" href="css/screen.css" type="text/css" media="screen" title="default" />
<link rel="stylesheet" href="css/jquery-ui-1.8.21.custom.css" type="text/css" media="screen" title="default" />
<!--[if IE]>
<link rel="stylesheet" media="all" type="text/css" href="css/pro_dropline_ie.css" />
<![endif]-->

<!--  jquery core -->
<script src="js/jquery/jquery-1.7.2.min.js" type="text/javascript"></script>
<script src="js/jquery/jquery-ui-1.8.21.custom.min.js" type="text/javascript"></script>


<!--  checkbox styling script -->
<script src="js/jquery/ui.core.js" type="text/javascript"></script>
<script src="js/jquery/ui.checkbox.js" type="text/javascript"></script>
<script src="js/jquery/jquery.bind.js" type="text/javascript"></script>
<script src="js/jquery/jquery.validate.js" type="text/javascript"></script>
<script type="text/javascript" src="js/jquery/geocoder.js"></script>
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?v=3&libraries=places&key=AIzaSyDe8jbfLwcLgh5ERFqcJUGDM_svl2foezQ&sensor=false"></script>

<script type="text/javascript">
$(function(){
	$('input').checkBox();
	$('#toggle-all').click(function(){
 	$('#toggle-all').toggleClass('toggle-checked');
	$('#mainform input[type=checkbox]').checkBox('toggle');
	return false;
	});
});
</script>  

<![if !IE 7]>

<!--  styled select box script version 1 -->
<script src="js/jquery/jquery.selectbox-0.5.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect').selectbox({ inputClass: "selectbox_styled" });
});
</script>
 

<![endif]>

<!--  styled select box script version 2 --> 
<script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_form_1').selectbox({ inputClass: "styledselect_form_1" });
	$('.styledselect_form_2').selectbox({ inputClass: "styledselect_form_2" });
});
</script>

<!--  styled select box script version 3 --> 
<script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_pages').selectbox({ inputClass: "styledselect_pages" });
});
</script>

<!--  styled file upload script --> 
<script src="js/jquery/jquery.filestyle.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
  $(function() {
      $("input.file_1").filestyle({ 
          image: "images/forms/choose-file.gif",
          imageheight : 21,
          imagewidth : 78,
          width : 310
      });
  });
</script>

<!-- Custom jquery scripts -->
<script src="js/jquery/custom_jquery.js" type="text/javascript"></script>
 
<!-- Tooltips -->
<script src="js/jquery/jquery.tooltip.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
	$('a.info-tooltip ').tooltip({
		track: true,
		delay: 0,
		fixPNG: true, 
		showURL: false,
		showBody: " - ",
		top: -35,
		left: 5
	});
});
</script> 


<!--  date picker script -->
<link rel="stylesheet" href="css/datePicker.css" type="text/css" />
<script src="js/jquery/date.js" type="text/javascript"></script>
<script src="js/jquery/jquery.datePicker.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
        $(function()
{

// initialise the "Select date" link
$('#date-pick')
	.datePicker(
		// associate the link with a date picker
		{
			createButton:false,
			startDate:'01/01/2005',
			endDate:'31/12/2020'
		}
	).bind(
		// when the link is clicked display the date picker
		'click',
		function()
		{
			updateSelects($(this).dpGetSelected()[0]);
			$(this).dpDisplay();
			return false;
		}
	).bind(
		// when a date is selected update the SELECTs
		'dateSelected',
		function(e, selectedDate, $td, state)
		{
			updateSelects(selectedDate);
		}
	).bind(
		'dpClosed',
		function(e, selected)
		{
			updateSelects(selected[0]);
		}
	);
	
var updateSelects = function (selectedDate)
{
	var selectedDate = new Date(selectedDate);
	$('#d option[value=' + selectedDate.getDate() + ']').attr('selected', 'selected');
	$('#m option[value=' + (selectedDate.getMonth()+1) + ']').attr('selected', 'selected');
	$('#y option[value=' + (selectedDate.getFullYear()) + ']').attr('selected', 'selected');
}
// listen for when the selects are changed and update the picker
$('#d, #m, #y')
	.bind(
		'change',
		function()
		{
			var d = new Date(
						$('#y').val(),
						$('#m').val()-1,
						$('#d').val()
					);
			$('#date-pick').dpSetSelected(d.asString());
		}
	);

// default the position of the selects to today
var today = new Date();
updateSelects(today.getTime());

// and update the datePicker to reflect it...
$('#d').trigger('change');
});
</script>

<!-- MUST BE THE LAST SCRIPT IN <HEAD></HEAD></HEAD> png fix -->
<script src="js/jquery/jquery.pngFix.pack.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
$(document).pngFix( );
});
</script>
<script type="text/javascript">
	function delete_oneway_rates(id){
		var $dialog = $(
					 "<div title='Delete'>"+
					 "<p style='margin-top:40px; font-family:arial; margin-left:35px;'>Are you sure you want to delete this?</p>"+
					 "</div>"
					);
		$dialog.dialog({
			autoOpen: false,
			modal: true,
			zIndex:9999,
			buttons:{
				"Yes": function(){
					$.post("query/delete_oneway_rates.php",{oneway_rates:id}, function(data){
						window.location.replace("affiliate_oneway_rates.php?id=<?php echo $_GET['id'];?>");
					});					
					$(this).dialog("close");
				},
				"NO": function(){
					$(this).dialog("close");
				}
			}
		});
		$dialog.dialog("open");
		return false;
	}
</script>
</head>
<body> 

<?php 
include("template/$header.php");
$page = (isset($_GET['page']))?$_GET['page']:'home';
		
	$id = $_GET['id'];
	require "query/db_connection.php";
	$q=mysql_query("SELECT
					affiliate.companyname
					FROM
					affiliate
					WHERE
					affiliate.affiliateid = '$id'");	
					
	$rowCount = mysql_num_rows($q);
	
while($row = mysql_fetch_array($q)){
	$companyname = $row['companyname'];
}

$acc_num = 0;
$class_alternate = "";

$q2=mysql_query("SELECT
				vehicles.image,
				vehicles.vehiclemodel,
				vehicles.capacity,
				vehicles.vehicletype,
				onewayrate.onewayid,
				onewayrate.affiliateid,
				onewayrate.rate,
				onewayrate.currency,
				onewayrate.distance
				FROM
				onewayrate ,
				vehicles
				WHERE
				vehicles.affiliateid = '$id'
				AND
				onewayrate.affiliateid = '$id'
				AND
				vehicles.vehiclemodel = onewayrate.vehiclemodel");	

if($rowCount!=0){
?>
<!--  start nav-outer-repeat................................................... END -->
<div class="clear"></div>
<!-- start content-outer ........................................................................................................................START -->
<div id="content-outer">
<!-- start content -->		
	<div id="content">

	<!--  start page-heading -->
	<div id="page-heading">
		<h1>
<?php
echo $companyname;	
?> Oneway Rates</h1>
	</div>
	<!-- end page-heading -->
	<div id="affiliate_airport_rate_subbutton">
		<ul>
			<li><a  href="<?php echo"add_affiliate_rates.php?id=".$id;?>"><img style="border:none;" src="images/forms/add_rate.png" /></a></li>
			<li><a  href="<?php echo"view_driver.php?id=".$id ;?>"><img style="border:none;" src="images/forms/drivers.gif" /></a></li>
			<li><a href="<?php echo"affiliate_vehicles.php?id=".$id;?>"><img style="border:none;" src="images/forms/vehicles.png"></a></li>
			<li><a href="<?php echo"notes.php?id=".$id;?>"><img style="border:none;" src="images/forms/notes.gif" /></a></li>
			<li><a href="<?php echo"view_affiliate_details.php?id=".$id;?>"><img style="border:none;" src="images/forms/back.png" /></a></li>
		</ul>
	</div>
	<div id="rates_submenus">
		<br />
		<br />	
		<ul>
			<li><a  href="<?php echo"affiliate_airport_rates.php?id=".$id;?>"><img style="border:none;" src="images/forms/airport_rate.png" class="dark_li"/></a></li>
			<li><a  href="<?php echo"affiliate_hourly_rates.php?id=".$id;?>"><img style="border:none;" src="images/forms/hourly_rate.png" class="dark_li"/></a></li>
			<li><a  href="<?php echo"affiliate_oneway_rates.php?id=".$id;?>"><img style="border:none;" src="images/forms/oneway_rate.png"/></a></li>
		</ul>
	</div>
	<br />	
	<br />
	<table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
	<tr>
		<th rowspan="3" class="sized"><img src="images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /></th>
		<th class="topleft"></th>
		<td id="tbl-border-top">&nbsp;</td>
		<th class="topright"></th>
		<th rowspan="3" class="sized"><img src="images/shared/side_shadowright.jpg" width="20" height="300" alt="" /></th>
	</tr>
	<tr>
		<td id="tbl-border-left"></td>
		<td>
		<!--  start content-table-inner ...................................................................... START -->
		<div id="content-table-inner">
		
			<!--  start table-content  -->
			<div id="table-content">
		
				<!--  start product-table ..................................................................................... -->
				<form id="mainform" action="">
				<table border="0" width="100%" cellpadding="0" cellspacing="0" id="product-table">
				<tr>
					<th class="table-header-check" id="head">No.#</th>	
					<th class="table-header-repeat line-left"><a href="">Vehicle Model:</a></th>
					<th class="table-header-repeat line-left"><a href="">Vehicle Type:</a></th>
					<th class="table-header-repeat line-left"><a href="">Capacity:</a></th>
					<th class="table-header-repeat line-left minwidth-1" ><a href="">Distance:</a></th>
					<th class="table-header-repeat line-left minwidth-1" ><a href="">Currency:</a></th>
					<th class="table-header-repeat line-left"><a href="">Rate:</a></th>
					<th class="table-header-options line-left"><a href="">Options</a></th>
				</tr>
				<tr>
<?php										
	while($row = mysql_fetch_array($q2)){
			$acc_num=$acc_num+1;
			echo"<tr class='". $class_alternate ."'>
							<td>".$acc_num."</td>
							<td><b>" .$row['vehiclemodel']. "</b></td>
							<td>" .$row['vehicletype']. "</td>
							<td>" .$row['capacity']. "</td>
							<td>" .$row['distance']. "</td>
							<td>".$row['currency']."</td>
							<td>" .$row['rate']. "</td>
							<td class='options-width'>
								<a href='' title='Delete' 	class='icon-2 info-tooltip' onclick='delete_oneway_rates(\"".$row['onewayid']."\");return false;'></a>
								<a href='affiliate_oneway_rates_view.php?id=".$row['onewayid']."&affid=".$row['affiliateid']."' title='View' class='icon-5 info-tooltip'></a>
							</td>
						</tr> ";
			if($class_alternate==""){ $class_alternate="alternate-row";}
			else{$class_alternate="";}
	}
?>
				</tr>
				
				</table>
				<!--  end product-table................................... --> 
				</form>
			</div>
			<!--  end content-table  -->	
			<div class="clear"></div>
		 
		</div>
		<!--  end content-table-inner ............................................END  -->
		</td>
		<td id="tbl-border-right"></td>
	</tr>
	<tr>
		<th class="sized bottomleft"></th>
		<td id="tbl-border-bottom">&nbsp;</td>
		<th class="sized bottomright"></th>
	</tr>
	</table>
	<div class="clear">&nbsp;</div>
<?php					
}
else{
	include"template/driver_transactions/error.php";
}		
?>		

<!--  end content -->
<div class="clear">&nbsp;</div>
</div>
<!--  end content-outer........................................................END -->

<div class="clear">&nbsp;</div>
    
<?php include"template/footer.php"; ?>
 
</body>
</html>